* DML 데이터 조작어
	데이터베이스에 데이터를
	입력, 조회, 수정, 삭제 하는 명령
	insert, select, update, delete
	
* insert
	하나의 레코드를 추가함.
	테이블의 모든 필드에 값을 추가하는 경우
	필드 목록은 생략가능.
	필드 목록과 values 절의 값은 1:1 대응
	문자, 날짜값은 ' ' 를 이용해서 값 추가.
	
* 모든 필드에 값 추가
	insert into 테이블 이름 
	values (필드값1, 필드값2, '필드값3',... ...);
	
	create table exam06(
	csid number(5),
	sjid char(4),
	csno number(4),
	title varchar2(30),
	crdt number(1)
	);
	
	insert into exam06
	values (11111,'CSCI',1301,'Introduction to Java I',4);
	
	select * from exam06;
	
* 일부 필드에만 값 추가
	insert into 테이블명	(필드1, 필드2, 필드3...)
	values (필드값1, 필드값2, '필드값3',... ...);
	
	insert into exam06( csid,sjid,title )
	values (111111,'CSCI','Introduction to Java I');
	
	select * from exam06;
	
* NULL 값 추가
	insert into exam06
	values (null,null,null,null,null);
	
	select * from exam06;
* sequence 추가
	가짜컬럼 nextval을 이용함
	시퀀스이름.nextval
	
	create sequence exam
	start with 1
	increment by 1
	nocache;
	
	insert into exam06 ( csid )
	values (exam.nextval)
	
	select * from exam06;
	
* 예제

create table Cstudent(
cnumber number(5),
sno number(9),
sname char(6),
addr varchar2(20),
age number(3),
birth date,
sjname varchar2(20),
prof number(3),
meet varchar2(10)
);
insert into Cstudent
values (exam.nextval, 201350050, '김태희', '경기도 고양시',25,'1985.3.22','컴퓨터공학',504,'목2교시');

select * from Cstudent;

create table Cdepart(
cnumber number(5),
sname varchar2(10),
tel number(14),
locate varchar2(10),
captain number(3),
mdate varchar2(10)
);

insert into Cdepart(cnumber,sname,tel,mdate) values (1,'고도리',01022244324,'2013-11-18');
insert into Cdepart(cnumber,sname,tel,mdate) values (2,'항아리',01033344324,'2013-11-19');
insert into Cdepart(cnumber,sname,tel,mdate) values (3,'헤이리',01044444324,'2013-11-20');
insert into Cdepart(cnumber) values (cnumber.nextval)

select * from Cdepart

create table Csubject(
cnumber number(5),
sjno number(4),
sjname varchar2(12),
sjinfo varchar2(25),
prof number(3)
);

insert into Csubject(sjno,sjname,prof) values (0205,'프로그래밍',301)
insert into Csubject(sjno,sjname,prof) values (0211,'드레스코드',445)
insert into Csubject(sjno,sjname,prof) values (5029,'생활의참견',556)
insert into Csubject(cnumber) values (cnumber.nextval)

select * from Csubject

create table Cprof(
cnumber number(5),
profno number(3),
pname varchar2(10),
pjun varchar2(10)
);
insert into Cprof(profno,pname,pjun) values (301,'이순신','프로그래밍')
insert into Cprof(profno,pname,pjun) values (445,'정약용','산업디자인')
insert into Cprof(profno,pname,pjun) values (556,'김유신','컴퓨터공학')
insert into Csubject(cnumber) values (cnumber.nextval)

select * from Cprof

create table Csec(
cnumber number(5),
sjno number(3),
sect number(1)
);
insert into Csec(sjno,sect) values (504,1)
insert into Csec(sjno,sect) values (301,2)
insert into Csec(sjno,sect) values (205,3)
insert into Csec(cnumber) values (cnumber.nextval)

select * from Csec

create table Cregister(
cnumber number(5),
sno number(9),
sjno number(4)
);


create table Ctech(
cnumber number(5),
tech number(3),
already varchar2(20)
);


select * from 
